Re: error message "column "oid" doesn"t exist"

Re: error message "column "oid" doesn"t exist"

am 05.01.2007 16:05:02 von Erika Marlow

This is a multi-part message in MIME format.

------_=_NextPart_001_01C730DA.E0D9F727
Content-Type: multipart/alternative;
boundary="----_=_NextPart_002_01C730DA.E0D9F727"


------_=_NextPart_002_01C730DA.E0D9F727
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hmm. Well, I am opening the tables for editing. All of the tables have =
unique primary keys that can be referenced. Is there a flag or something =
I can set to prevent it from looking for oid?
=20
Thanks,
Erika

________________________________

From: Oberle, Martin [mailto:martin.oberle@winntec.de]=20
Sent: Wednesday, January 03, 2007 1:36 PM
To: Erika Marlow
Subject: AW: [ODBC] error message "column "oid" doesn't exist"


As far as I know the odbc driver uses the oid to identify the records =
when updating records.
The driver adds the column oid to the query when the driver thinks that =
records mjight be updated
in the future. The error should not occure whe you open the table =
"readonly".
=20
good luck
=20
martin
=20

-----Ursprüngliche Nachricht-----
Von: pgsql-odbc-owner@postgresql.org =
[mailto:pgsql-odbc-owner@postgresql.org]Im Auftrag von Erika Marlow
Gesendet: Dienstag, 2. Januar 2007 19:00
An: pgsql-odbc@postgresql.org
Betreff: Re: [ODBC] error message "column "oid" doesn't exist"
=09
=09
We are recieving the error message "column "oid" doesn't exist" from a =
series of ODBC calls via ADO in a Visual Basic application. The SQL =
statements are all "SELECT * FROM

" where
refers to =
several different tables. No tables were created with OIDs, because we =
don't use them. So, the statement in the error is true, but we've been =
using the same application without issues for quite some time.
=20
We're still using the 8.01.0200 drivers, UNICODE in this particular =
case, and if necessary can upgrade (but it's a painful process).
=20
Any suggestions for resolving the issue without updating to the latest =
drivers?
=20
If updating is the only option, do the new installation packages for =
the driver take care of any ANSI/UNICODE differences? What are the =
rules for moving from one to the other? =20
=20
Thanks,
=20
Erika Marlow___________________
Senior Software Specialist
National Information Solutions Cooperative
One Innovation Circle
Lake St. Louis, MO 63367
**Email: erika.marlow@nisc.coop =20
**Phone: 866.WWW.NISC (866.999.6472)
**Direct: 636.755.2519 =09
=20


------_=_NextPart_002_01C730DA.E0D9F727
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable



charset=3Diso-8859-1">


face=3DArial=20
size=3D2>Hmm.  Well, I am opening the tables for editing. All =
of the=20
tables have unique primary keys that can be referenced. Is there a flag =
or=20
something I can set to prevent it from looking for =
oid?

face=3DArial=20
size=3D2>
 

face=3DArial=20
size=3D2>Thanks,

face=3DArial=20
size=3D2>Erika





From: Oberle, Martin=20
[mailto:martin.oberle@winntec.de]
Sent: Wednesday, January =
03, 2007=20
1:36 PM
To: Erika Marlow
Subject: AW: [ODBC] error =
message=20
"column "oid" doesn't exist"



class=3D758273119-03012007>As far=20
as I know the odbc driver uses the oid to identify the records when =
updating=20
records.

class=3D758273119-03012007>The=20
driver adds the column oid to the query when the driver thinks that =
records=20
mjight be updated

class=3D758273119-03012007>in the=20
future. The error should not occure whe you open the table=20
"readonly".

class=3D758273119-03012007> 

class=3D758273119-03012007>good=20
luck

class=3D758273119-03012007> 

class=3D758273119-03012007>martin

class=3D758273119-03012007> 

style=3D"PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px =
solid; MARGIN-RIGHT: 0px">
face=3DTahoma=20
size=3D2>-----Ursprüngliche Nachricht-----
Von:=20
pgsql-odbc-owner@postgresql.org =
[mailto:pgsql-odbc-owner@postgresql.org]Im=20
Auftrag von
Erika Marlow
Gesendet: Dienstag, 2. Januar =
2007=20
19:00
An: pgsql-odbc@postgresql.org
Betreff: Re: =
[ODBC]=20
error message "column "oid" doesn't exist"


We =
are recieving=20
the error message "column "oid" doesn't exist" from a series of ODBC =
calls via=20
ADO in a Visual Basic application.  The SQL statements are all =
"SELECT *=20
FROM <table>" where <table> refers to several different=20
tables.  No tables were created with OIDs, because we don't use=20
them.  So, the statement in the error is true, but we've =
been using=20
the same application without issues for quite some =
time.

size=3D2> 

size=3D2>We're still using=20
the 8.01.0200 drivers, UNICODE in this particular case, and if =
necessary can=20
upgrade (but it's a painful process).

size=3D2> 

Any =
suggestions=20
for resolving the issue without updating to the latest=20
drivers?

size=3D2> 

If =
updating is the=20
only option, do the new installation packages for the driver take care =
of any=20
ANSI/UNICODE differences?  What are the rules for moving from one =
to the=20
other? 

size=3D2> 

class=3D985254317-02012007>Thanks, class=3D985254317-02012007>

 







title=3D"NISC Homepage - www.nisc.coop" =
src=3D"cid:974010315@05012007-2C96"=20
border=3D0>
Erika=20
Marlow
___________________
size=3D1>Senior=20
Software Specialist
National Information Solutions =
Cooperative
One=20
Innovation Circle
Lake St. Louis, MO 63367
color=3D#e70042>Email: =
color=3D#999999> color=3D"#999999"=20
erika.marlow@nisc.coop

color=3D#e70042> face=3Dwingdings>( Phone: color=3D#999999>866.WWW.NISC=20
(866.999.6472)
face=3Dwingdings>( Direct: color=3D#999999>636.755.2519
=20
=
>
size=3D2> 


------_=_NextPart_002_01C730DA.E0D9F727--

------_=_NextPart_001_01C730DA.E0D9F727
Content-Type: image/gif;
name="nisc.gif"
Content-Transfer-Encoding: base64
Content-ID: <974010315@05012007-2C96>
Content-Description: nisc.gif
Content-Location: nisc.gif

R0lGODlhfgBbAOYAANmvrMU1TDAwLMlFU9zb28zLy769vLS0tJ1rb/DOx6kC OfT09PHx8Z2dne/v
7+ezqcPDwpKSkujBu5ACMLwDQaKioklJRIuLioGBgODg4KuqqoaFfE84N3V0 dGJkWvv7+1MCGHJy
avr6+ubm5nt7e2tra+np6ZOSiWJiYtXV1ayMi9JoZ3cCJlxcW/j4+NDQ0KOi mltcU1RUVOSlmm9R
Ubazrdh6dlNTTd2LgkVDPm1tY52blNjGxMF5guGaj/fp535+dNuDfMMkRqqp pYuKgN6TiMxUW7q5
uNmUlV5GRUADErCvrcaal7ZCXfn089VxbL8JQ14rMdWno+DQzY+PjvLk4vjx 78jIx/Pc2KempBwc
GZeXlc5gZIaGhkQgIqMwTXkcMn5hYSYnI9jU1OPj4/39/WEDHfv4+Ozr6tPS 0tjY2MCWjv///9Fv
ek5OSv7+/mZoYV9gVldYUzs8Nnd3bXcxPff3982hoOrq6MuJiuzs7KURQNfW 0vn5+d+goMAURSH5
BAAAAAAALAAAAAB+AFsAAAf/gGyCg4SFhoeIiYVvjB8fIn0udgsLDJaXDpkO l5aUC3YufY4fjG+K
p6ipqquJpY59VlUJEg8zPkVBQTa7vLtBOEh+DxJTIyZ4epuUdqIfZYys0dLT h4xlH30/CbVFOLm8
T08r4+TjXOfo5yttSABTZMbJDJ/NpdT3+NVv11ZY3DjebIg7Z8TIgIMDAgRI qBDhwYIQIXKxIWVK
BnholLlwZC+fx2jWnPi7FfAJF4MJhaj8AwUKBQouYcZs+eePSiENHyLkkocH gQzGNDqD9rFoqzcf
fkiYUQSXjRUGA6iM+bKq1atYYcpUmROhkZ5qgOJx8EkEKVNG07KxNtIHjqcG /4WwpJq1rl2sUGzi
VKiQy50xP0fomSfqGVq196xVqeUjyJO4f17SvUs5qwIKCi5fhrlX6oA8L1IQ IINm3sZniKnt+8E4
CFSpkyvLxpx5gu3buG1nfnkzQA8eaUbjIXw29SpGThLYwvE4AMvZ0GvbZsHC jBkQ2LODsG6GOgvd
FPT2KBCcNAM7Zokab1XGH9Pmz6FXrk39upL7Srx44ZAkR5IbSQSYBAdRWEfd BLvlxQR5BAh23lDr
IfLGGco1xgVs8lFGn3337ZeDG3LI0QIKI8JRwokhdKCiimHQUMeBmzUBQAEp AEWWKOpFyAhr7w0g
RGwZWqXAdCB0yIEFbsggIv8KKJyoIgkkYCBlF1RWaSUCLyKoABQ9XPHCaIPZ AaGOb7gXxIWRBVnX
kBOYgZ8XFiApw4glpBhlFxdEsMUWDTRQwZ9/9tnAnlvouQUCYCBIQRMG0JiB CTcWlxoj2/hggxE/
qmnZBNUZ6cYNczYZwp1U8FmBBksccMARBrTqqgFHqLqEBhoEWsEJX2QGBRNX BDcCWRvlWNQ+2xTx
hI9ABplZp/nlICedHWCQp58arAoBBFcU8EIaKXTrbQovvFDAFdfGesCsQ6iQ qwJdfkmGHgsEe9hH
xDK1gnOaXlWbm81aACoKcHRAQhdUNJDFEqxmm4YaP100gjEmRPzwCGRkQAD/ AeCOC4EBqh6gwh4K
GOElmAycNi8+xD5QxL1p5vvSkCwUud+zdZJwwRanHmCAlwzDY4I883gidCUM OICGCRVj/AK5rR6B
gAJNaEuyyR7Vu3IAycq3LL8cfDhnwDbjjDAEL/T8c9ChmOVIGWyzPYoIklRi 9AgWZ3ztHXt8QSOY
8UqaWLH3Zh0dpx3GGWoJYVewxM7lnR2vWYadbIgr2EziAB50q5HG0lc08UXZ NvYtLCtlqhy4y7S1
eZ+zILZQQgddRKB4o6KNUNrjZ0meijUfuFCJHhRjnEYBPTQh2qPzpKcaaz48 ga/LyxZuQajRFrz4
FTU6yMxQukvTiAh2FI00/wFqpMBED2E5KK/3TixlwwAtazok13I2GfYQR0Dg a5jpdY8yUuATX9IA
cIeLDAc9qAGJcoLgI9QNSWbO+loIMCC7A5CNZOjx26QAGD49IC0D7xjBWBaA I5BgYQY4GEBMNsPC
l7kQMy5cFgST5DrYbUEDR8BeBg7YvwgRYh+9+50JHua4YJHuB80TAptyw8Qm 4oZ+SbJfwSz4pV+R
UIM+FEQjglg0Pchje6NrBQ4CoIDqcOeMaEwjGoukBK+1IGCxy0IOU2AeqmVR QtfowyQqQQkX9FAV
P2hDDxCAgDC0iAYC4oAiF8nIRjLyBi2gU9gWV4AGRSqMdxzEFiMBCj+OSf8V SFmAHghwhQNUgAoY
6MCJVsnKVroSRVGy3gVNcB4RJDCTiuDdKNaGyWqUwQUMGIEaSlmBLVxASshM pjKhxEwoTalUB2sU
30xWCl3u8prOiJw+rInNXUauFG2rJiixIUoypOAKR9DAoCLAzj0J6p2DKlQE qEAFdh5MA0NA1RKG
kAU6Dqdvb4sbJTjBCU+AgpfVvAbc9kg0gnZiGZ7kXkdU4YAjDGEHJzjBnk6w AQ/grAJZQNWqjpA/
i2L0BECIgwf8lAUD1AAGGSVCCCAZnEeRZQEmUEMBXLoEGPj0p0MYwhJqkD8C IMM0a3MEGgjwAggc
oQZZ+KlPs5BPnZHtUV//LIz/WkGAI2ThBEQIKxE2MFM4hBRhO9OWuLwKViDE YA5mrdYQtgCEEIQA
Dm4QAAmyVaMMXAGqMNjBFmIq1rFuYKx0iEEOthCYMC2ADH+NqmAJG9YNWFas G6BDHNzQgNFASnTS
KAMEloBSOpiWDiHwgBvmsIWD5fBLFzEAaVH7Vi10IWdE0EEMbnCDvGqhAasq wGiHAFMiAEEHcYhB
iJYbA5V64AZzEMBr1QCPF9SAuBg17l2TG6IbhKi5HtCBDuQQ3SMwyIoi2Go1 8PBSIMDBA/CF72bn
gILWHkCHmGsvHOJgATEIQE8VOEANBLyEr6rST6x6KUdDwN/oiuHBDxaA/4Tn MAcxaCEEqTKAuGrQ
0y0YFw5ysEB0BQBhEktYAHPIQQ4EoIUSjO1LtHRBGUCSBtKmNr7xvUEO5tCF GxogDe9Sw2w9QF4t
3EBarY3VXDsqgBIU7KkwyKxuLUBiNzSpTnZVZQv6+1+Dteq6HKXDcyusBS0I wA1vxHKKSoCCG7BY
DLKrFgSo6wAxqbcQIjBAFjaw3xj4Ob4xEDEcugDcKxgVAkPI7XNZjAKBCXas QDhuXqUl1Cjr4L1y
2HEzMYCnC9CTnZ6OAHBdCgMi0AEOin3zDaLF6U7Ts57sjAAJOmAqCwK5zh8g HRpqsAMgENkNn4oD
HPYL3Rx04AIV+DEZ9P/L3wc36dhZsKpFu3DsC/j0BHeFbwzcYIFVjorT9SSU OzXg0l6nVrEWNvaT
7hRqcbu7AXKmowNkTLoaYzvQc3BDcy/tgUALAAUk2MISvLSELYi5yHMYUQgE fq6vwmEOcqCSh48b
3zjI4QYxWHO0pvWnLHh8CLCCAcU3y+IbeDtKeeKTx2nF8pVXS5ojYEAf7kyI PO95vBWWAQo8EAId
eGC+Fjh2shGtaDcbeURUkC0MBksHN4ghBHjawrnB+3OV6oAOGNhAqaiVKlU5 dQgb4HeRc8AkE1XP
YKli1bWu9aprFYC68CLFcXbda9WyuAVyuHq2Mz2HEmBgC1B2b7PF8DX//H01 szGQMJVuRoTeAtu7
MfAAHEJAh0hHegMRSLsBrlXwU8PX6HN6Y7Rkdz1tdUsNqO9WGrjVs8EYEZQv sDF/zYz3DgCBDj7f
9hxkcOwjLGEHYq5twl3H4RPgPg45MLKUblaBBjw8xayTg7Apf9rUEkHtRyi1 z3/udAHIQOd+j4Ac
sRcYiEVsiBMzQUZAu4oP6DnsY48kCiKdbR13GwM10AC2F310FHRBv/zXaGFz MAfQAB2wWhT2IZEH
B+IlXs8VAqzye2EnX3klAN4VMFTQUpXkIEFjBww1NJ7US5NDd75mdPI3aLeX e9wmMD0VdoP3NYpj
cD/XX2JwIgPTAGjl/3sNcAEdgALcdgOS917Dtlk5cAE9hVLbN2b55joYAFyV xENr0zbXcE3adBz2
xmAWoAViwCSN1gUbUFfEdgMhsAFZQFeoNgdaMHwlcF2Kplhp+GzIZkEFIFym ZExSUle4B2hU1gJb
sANfmIR8h2ZQl2wpEHO2tFUTFQ1l8H44pwVkJ0W9lodxEAchcAELxn9ohgL4 J3LvZXRohoEamAKa
cwWylQUNEAE3Q1bvRWQVlgN/Z1pJGAc3YAEiAm0QUIgLcIjVtA/hlIjHwV51 Z3RywCSwg4MYAIbw
dXVgOHgiAgcxeGqb9WBzUgIEQ25fcjEpIFyxgipDYHzvtW0sZmxSsv+KgHZx cDAwFXAEL5AB8NJJ
LiAJmeCBocA93sMHskeDTII4EYBDIud5kidewyZ8IuJiiZZ7yed9fHhRMCCH qScuTPNSuWVxVFZm
MvA6XaBbfuZcPxdeQCBw+vMTSZMGBnACcJACXjQPGURzhbCIewZiaEhfTdKE FgQBKYhj8mV006OJ
AAhdWpCT+cdRh0UEGrUDRLkDPrUFfCYHq2VhPSkHcBQBIfB4GNdcDFh5hzWU grUnQKCUFwMUYSJ3
pDMCWUAEINZfWjCMjXYBLRUaDXBuvPWWPCkGIAIHWxBlRKZjFgYqF+CHl6YD IWB5gHl8OkZmZjY9
rkMCBVMBF6BjzoL/JBgneZQXmKeWV3KQLe4CL30wY6RzBG61Y2+WjwF3Xz9R ALK4YxR2mhbmfU1i
cHxHZgKgcKq1YyoWJ8AWJ6ZJYmUmBrsnf4hzAfCmKkPQBeSFYqfZmHFiAbdZ Zh1gLVVUMpq5Cn1A
BA2GmzngJMimbEO0AZ5JYhBWZmjmd3SQaRL2YFpgZedIAgzGbSMGYRGWYpC0 Iqt0dtdDLqZEBT3o
BtsZYRM2B9MDB6SXQ3RGb6xQBg4gTBBQgF3ATD02cAQAKXrgVwiqSkwSSSZi M9QyBKeYSh3wbaKW
T6a4BVRQJRfgafQ0ol2AAczEaRVENt2yNBbVAKjUTM7kap+mchYk/28Cehx9 wADmBAHqRAWe5mO3
Rgl4QAAFYEoRkKCzJjAE85uwcgBleExRpziyUivrFGux9mojGm6/CQF7Qz5N lU6DcgEnqkwiOqKi
Fm1zFnM5Cko7agJGmk6AsjhfggfxAkzChE7qJE96gnabNy4cY6XUYlUb43u1 Eijw5Cd/cgQAIAWO
6qgAEKmS+qh3cAdMcKlrkKmaugYqMEjsBG/m1aC5qJKa9AHlpFOFunkwVjKO YAcFaqROdS5LoHk8
g3pL41Qk9aehsTlMYy4d86skxQNMIRDhUKzGeqzIGg5QQQETUAcFo6ZApgd2 BhK9wwB6QAbCExo/
QUtiwjYisAAFmv8BmiMuc2h6IEkxdRMuodEzZJA041qu4wKvL8ADD2ApJxER +Jqv+kpGLKAEJCBq
OFRJtJSZpLoWHCQ+FOMz/GMYj9BBQ1QxGRCxCrsJDuBBCTuxmaAHR4OuEdux ErsUzZMSNzGyJFuy
N8GsbkIDsYODGsaOCwCWqVAFuqRHA3UJ9AAhvBM3lqAJDyWPe0RQECUJP1s0 mpAJi2EvDQQ9bhIF
G4eDt0gGzkmqEpAAb9MHVtsHIqA2CPVDQOQIWfu13fQ2WptNbbNLWRsJLjAS Z4I1DtSvXoACo+Kb
A6cGJjCqAyoMCwUK9SCCPlQK7WMLl5Ip0NOvSmBlr+ObB1BJcUf/qoxwBjaA BJPQgVqFS5PTHrWA
AyuALA40AUXCAV9jM+n4AmQwbzCLCo3gBFzQBlXgRUKBRVnECFYAskFgBM8D PZyrBEcCSX7nkXSb
i7e0O9jwAwYhAUQ0GH3zu2RCIZd7LIJruzKDJHKAOBmobKRbsGtROVVwITYA kmeTktYLEkjhHkVw
KbXrvPkBvWkZui5buqBUBgFkAhcyAFLAvZvgvYjRCEfbGJnbvOYLJ1F0bE5o VL77vY3gO8CTBzhh
BABgNvX7R/lgDSKQv67hI/GTLzJ0vv9LaKIZY+x7HI9QCSaQAXdgEwPABQBw MfBgvNQ0Da4gEvXa
GPAhONFRRvdx/yQg0oWFpgZs2sHHgRS+E6480AQUsBBGcAdTEBgjtD25cwrg 9AFnUAUgiwuvER+o
gxmqg7tIMiLFuARr+iDfuwg+XE4Y0wNbshAD0AYVERgZgZIRRbZu47V9IBJR /BaZ6xwyPMMx0y/T
CMAWpMO4xre7cw3AdK0EkAZHkCtD/BDs4A7tqn6bEDRDswBogAW0cAvdIBCQ cceDQ7he4Ea9GWBX
4Md29sW+VK2EnAZX8DGXIQQDIBErEARIIAXDQAwSUMsP8AB+0A0A8Q1QkRKa vMlsFEHDOEEVFMq/
MsppUcBijMoGgADgQcRGoA7jEA690AsDQbsYUsVCwin84r973P9j+LOBXkzK uRTGr8rMNeDM4IET
D1EQ6XCvByEVP/LLWmMb3ew1w9ibLLuqyLxB5OQAIZyNB6oBiHIbu6EXJTsX 2mwZMHPP05PPsLOi
NTIc66Mj19BB2BqmBYYl36Ebu7HQGsImedwswBZJr4MB1tMocHdFgEwvSNEH 4Eo32QgrtXICYQAG
B+LRmwHStCHS/ILBSvJsSDYEtoY8CETOqnHR1joChUyKUDooG0ADOJ3TOr3T M5wZPv3TnZwkS3LS
N6Oml3m8SJ0YB4sGGU2KBXaKxxQGdQAG3eEdTITVci3XuVEf2NEhnQwqXf1t 0KQzb4c8uei6lNsI
MM0AeICtzHz/AHtKprMWBklQINzhHZI92QZiHXdtJBzwKUsiKtGysnLmKFZk R5SLR1xk1hijjWlt
TEqqSnGASFEQBV7ARvgx2/qxH7mrJPJ3ZQIjLaKmOPnz16FNj6Ndznn0O3RT yKhtpah4okvKSnDA
hdA9ItDtbU8CbqaSYTxjU2Uh2MMtIRwErpgjrsOzMedipYVCpmXKTCuy3gKT oovXpzmTPzzjWcDC
EWOdSTkrN0OUrsL1pLOSBc0XT1g64IbSJyAlUmqnLWajwsLd3aqxRb5TNGiA ruSzOcK1MU/aMbO6
4V2nKrl6LV6yMNyrwpDT0g6+O5sUuRX7sBZTPuASLvAa42q1Ui2ieK4/oxEl ft8n7t1TSLNyowd4
gH7t6rFEfhHwYAzIoAzxsrc6vuMojhSvIFANtbM8C7SfkDb23eRO/uDc5LVf m7XYxDa+uOVkXuZm
fuZnHggAOw==

------_=_NextPart_001_01C730DA.E0D9F727--